Overview

Dataset statistics

Number of variables14
Number of observations2506983
Missing cells569378
Missing cells (%)1.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 GiB
Average record size in memory512.4 B

Variable types

NUM8
CAT5
BOOL1

Reproduction

Analysis started2020-07-12 17:17:33.546041
Analysis finished2020-07-12 17:20:35.299374
Duration3 minutes and 1.75 second
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

start_time has a high cardinality: 2502118 distinct values High cardinality
end_time has a high cardinality: 2502116 distinct values High cardinality
start_station_name has a high cardinality: 446 distinct values High cardinality
end_station_name has a high cardinality: 446 distinct values High cardinality
end_station_longitude is highly correlated with end_station_latitudeHigh correlation
end_station_latitude is highly correlated with end_station_longitudeHigh correlation
start_station_id has 80734 (3.2%) missing values Missing
start_station_name has 80133 (3.2%) missing values Missing
end_station_id has 82902 (3.3%) missing values Missing
end_station_name has 82350 (3.3%) missing values Missing
bike_share_for_all_trip has 243259 (9.7%) missing values Missing
duration_sec is highly skewed (γ1 = 61.41479711) Skewed
start_station_latitude is highly skewed (γ1 = -103.0494041) Skewed
start_station_longitude is highly skewed (γ1 = 309.5870215) Skewed
end_station_latitude is highly skewed (γ1 = -125.689168) Skewed
end_station_longitude is highly skewed (γ1 = 165.6630369) Skewed
start_time is uniformly distributed Uniform
end_time is uniformly distributed Uniform

Variables

duration_sec
Real number (ℝ≥0)

SKEWED

Distinct count15280
Unique (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean807.6483298849653
Minimum60
Maximum912110
Zeros0
Zeros (%)0.0%
Memory size19.1 MiB

Quantile statistics

Minimum60
5-th percentile182
Q1359
median571
Q3887
95-th percentile1760
Maximum912110
Range912050
Interquartile range (IQR)528

Descriptive statistics

Standard deviation1974.713981
Coefficient of variation (CV)2.445017104
Kurtosis18790.78908
Mean807.6483299
Median Absolute Deviation (MAD)246
Skewness61.41479711
Sum2024760633
Variance3899495.305
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
33932980.1%
 
37032680.1%
 
37232510.1%
 
35332440.1%
 
35532420.1%
 
38332360.1%
 
39032330.1%
 
32432310.1%
 
37532210.1%
 
34032180.1%
 
38032140.1%
 
38432140.1%
 
36432130.1%
 
35832130.1%
 
31332120.1%
 
34932120.1%
 
38732080.1%
 
32732060.1%
 
39532060.1%
 
35932050.1%
 
38632040.1%
 
39632030.1%
 
38132020.1%
 
34732010.1%
 
34631990.1%
 
Other values (15255)242642996.8%
 
ValueCountFrequency (%) 
6038< 0.1%
 
61298< 0.1%
 
62291< 0.1%
 
63307< 0.1%
 
64288< 0.1%
 
65300< 0.1%
 
66324< 0.1%
 
67317< 0.1%
 
68318< 0.1%
 
69341< 0.1%
 
ValueCountFrequency (%) 
9121101< 0.1%
 
862301< 0.1%
 
862171< 0.1%
 
861142< 0.1%
 
859521< 0.1%
 
859351< 0.1%
 
859041< 0.1%
 
857021< 0.1%
 
856761< 0.1%
 
855451< 0.1%
 

start_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count2502118
Unique (%)99.8%
Missing0
Missing (%)0.0%
Memory size19.1 MiB
2019-07-30 07:59:17
 
5
2019-07-31 08:25:09
 
4
2019-07-27 18:57:16
 
4
2019-07-24 08:46:17
 
4
2019-07-25 07:51:36
 
4
Other values (2502113)
2506962
ValueCountFrequency (%) 
2019-07-30 07:59:175< 0.1%
 
2019-07-31 08:25:094< 0.1%
 
2019-07-27 18:57:164< 0.1%
 
2019-07-24 08:46:174< 0.1%
 
2019-07-25 07:51:364< 0.1%
 
2019-07-24 08:57:124< 0.1%
 
2019-07-27 17:23:454< 0.1%
 
2019-07-23 08:31:174< 0.1%
 
2019-07-24 07:58:163< 0.1%
 
2019-07-22 17:27:103< 0.1%
 
2019-07-30 12:19:033< 0.1%
 
2019-07-29 08:39:023< 0.1%
 
2019-07-27 12:23:023< 0.1%
 
2019-07-21 15:39:483< 0.1%
 
2019-07-23 17:04:533< 0.1%
 
2019-07-22 12:51:233< 0.1%
 
2019-07-27 15:41:203< 0.1%
 
2019-07-26 17:51:043< 0.1%
 
2019-07-23 17:16:243< 0.1%
 
2019-07-25 12:15:393< 0.1%
 
2019-07-24 09:23:323< 0.1%
 
2019-07-27 15:40:153< 0.1%
 
2019-07-28 16:18:453< 0.1%
 
2019-07-25 08:24:203< 0.1%
 
2019-07-24 09:11:093< 0.1%
 
Other values (2502093)2506899> 99.9%
 

Length

Max length24
Median length24
Mean length23.75899717
Min length19

Overview of Unicode Properties

Unique unicode characters14
Unique unicode categories (?)4
Unique unicode scripts (?)1
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
01103296318.5%
 
1838377314.1%
 
2635133610.7%
 
-50139668.4%
 
:50139668.4%
 
945480907.6%
 
328191464.7%
 
426581824.5%
 
526133184.4%
 
25069834.2%
 
.23861454.0%
 
821884533.7%
 
721537823.6%
 
618932993.2%
 

Most occurring categories

ValueCountFrequency (%) 
Decimal Number4464234274.9%
 
Other Punctuation740011112.4%
 
Dash Punctuation50139668.4%
 
Space Separator25069834.2%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
01103296324.7%
 
1838377318.8%
 
2635133614.2%
 
9454809010.2%
 
328191466.3%
 
426581826.0%
 
526133185.9%
 
821884534.9%
 
721537824.8%
 
618932994.2%
 

Most frequent Dash Punctuation characters

ValueCountFrequency (%) 
-5013966100.0%
 

Most frequent Space Separator characters

ValueCountFrequency (%) 
2506983100.0%
 

Most frequent Other Punctuation characters

ValueCountFrequency (%) 
:501396667.8%
 
.238614532.2%
 

Most occurring scripts

ValueCountFrequency (%) 
Common59563402100.0%
 

Most frequent Common characters

ValueCountFrequency (%) 
01103296318.5%
 
1838377314.1%
 
2635133610.7%
 
-50139668.4%
 
:50139668.4%
 
945480907.6%
 
328191464.7%
 
426581824.5%
 
526133184.4%
 
25069834.2%
 
.23861454.0%
 
821884533.7%
 
721537823.6%
 
618932993.2%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII59563402100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
01103296318.5%
 
1838377314.1%
 
2635133610.7%
 
-50139668.4%
 
:50139668.4%
 
945480907.6%
 
328191464.7%
 
426581824.5%
 
526133184.4%
 
25069834.2%
 
.23861454.0%
 
821884533.7%
 
721537823.6%
 
618932993.2%
 

end_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count2502116
Unique (%)99.8%
Missing0
Missing (%)0.0%
Memory size19.1 MiB
2019-07-22 08:35:41
 
4
2019-07-25 10:30:53
 
4
2019-07-27 18:08:44
 
4
2019-07-26 10:04:08
 
4
2019-07-25 08:17:40
 
4
Other values (2502111)
2506963
ValueCountFrequency (%) 
2019-07-22 08:35:414< 0.1%
 
2019-07-25 10:30:534< 0.1%
 
2019-07-27 18:08:444< 0.1%
 
2019-07-26 10:04:084< 0.1%
 
2019-07-25 08:17:404< 0.1%
 
2019-07-26 18:19:523< 0.1%
 
2019-07-30 17:20:543< 0.1%
 
2019-07-28 15:50:473< 0.1%
 
2019-07-29 08:38:393< 0.1%
 
2019-07-26 13:53:143< 0.1%
 
2019-07-25 17:26:233< 0.1%
 
2019-07-24 07:54:383< 0.1%
 
2019-07-31 07:54:413< 0.1%
 
2019-07-26 17:25:133< 0.1%
 
2019-07-24 11:52:183< 0.1%
 
2019-07-22 12:27:283< 0.1%
 
2019-07-20 13:20:183< 0.1%
 
2019-07-22 19:14:243< 0.1%
 
2019-07-31 08:56:483< 0.1%
 
2019-07-23 17:28:313< 0.1%
 
2019-07-19 09:32:093< 0.1%
 
2019-07-23 06:52:383< 0.1%
 
2019-07-31 08:51:243< 0.1%
 
2019-07-20 17:26:413< 0.1%
 
2019-07-26 18:44:373< 0.1%
 
Other values (2502091)2506903> 99.9%
 

Length

Max length24
Median length24
Mean length23.75899717
Min length19

Overview of Unicode Properties

Unique unicode characters14
Unique unicode categories (?)4
Unique unicode scripts (?)1
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
01101423318.5%
 
1837790314.1%
 
2640665810.8%
 
-50139668.4%
 
:50139668.4%
 
945878947.7%
 
328161634.7%
 
426364004.4%
 
526246074.4%
 
25069834.2%
 
.23861454.0%
 
821902843.7%
 
721183153.6%
 
618698853.1%
 

Most occurring categories

ValueCountFrequency (%) 
Decimal Number4464234274.9%
 
Other Punctuation740011112.4%
 
Dash Punctuation50139668.4%
 
Space Separator25069834.2%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
01101423324.7%
 
1837790318.8%
 
2640665814.4%
 
9458789410.3%
 
328161636.3%
 
426364005.9%
 
526246075.9%
 
821902844.9%
 
721183154.7%
 
618698854.2%
 

Most frequent Dash Punctuation characters

ValueCountFrequency (%) 
-5013966100.0%
 

Most frequent Space Separator characters

ValueCountFrequency (%) 
2506983100.0%
 

Most frequent Other Punctuation characters

ValueCountFrequency (%) 
:501396667.8%
 
.238614532.2%
 

Most occurring scripts

ValueCountFrequency (%) 
Common59563402100.0%
 

Most frequent Common characters

ValueCountFrequency (%) 
01101423318.5%
 
1837790314.1%
 
2640665810.8%
 
-50139668.4%
 
:50139668.4%
 
945878947.7%
 
328161634.7%
 
426364004.4%
 
526246074.4%
 
25069834.2%
 
.23861454.0%
 
821902843.7%
 
721183153.6%
 
618698853.1%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII59563402100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
01101423318.5%
 
1837790314.1%
 
2640665810.8%
 
-50139668.4%
 
:50139668.4%
 
945878947.7%
 
328161634.7%
 
426364004.4%
 
526246074.4%
 
25069834.2%
 
.23861454.0%
 
821902843.7%
 
721183153.6%
 
618698853.1%
 

start_station_id
Real number (ℝ≥0)

MISSING

Distinct count436
Unique (%)< 0.1%
Missing80734
Missing (%)3.2%
Infinite0
Infinite (%)0.0%
Mean146.50474910036027
Minimum3.0
Maximum498.0
Zeros0
Zeros (%)0.0%
Memory size19.1 MiB

Quantile statistics

Minimum3
5-th percentile8
Q147
median105
Q3243
95-th percentile376
Maximum498
Range495
Interquartile range (IQR)196

Descriptive statistics

Standard deviation122.3171024
Coefficient of variation (CV)0.8349019614
Kurtosis-0.5575613587
Mean146.5047491
Median Absolute Deviation (MAD)79
Skewness0.7718204869
Sum355457001
Variance14961.47353
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
58450581.8%
 
81429621.7%
 
30403021.6%
 
15390161.6%
 
67365761.5%
 
21360811.4%
 
3342531.4%
 
16324481.3%
 
22313411.3%
 
5305811.2%
 
6287851.1%
 
50244241.0%
 
66230930.9%
 
17220940.9%
 
93214370.9%
 
90211160.8%
 
27208180.8%
 
44205510.8%
 
104200150.8%
 
23192190.8%
 
61183350.7%
 
243173020.7%
 
19171580.7%
 
114171000.7%
 
350161270.6%
 
Other values (411)175005769.8%
 
(Missing)807343.2%
 
ValueCountFrequency (%) 
3342531.4%
 
471150.3%
 
5305811.2%
 
6287851.1%
 
7100680.4%
 
8105140.4%
 
9105840.4%
 
1095330.4%
 
11117520.5%
 
1233790.1%
 
ValueCountFrequency (%) 
49811< 0.1%
 
49522< 0.1%
 
49420< 0.1%
 
493388< 0.1%
 
49269< 0.1%
 
49139< 0.1%
 
49042< 0.1%
 
48946< 0.1%
 
48816< 0.1%
 
487391< 0.1%
 

start_station_name
Categorical

HIGH CARDINALITY
MISSING

Distinct count446
Unique (%)< 0.1%
Missing80133
Missing (%)3.2%
Memory size19.1 MiB
Market St at 10th St
 
45058
Berry St at 4th St
 
42962
San Francisco Caltrain (Townsend St at 4th St)
 
40302
San Francisco Ferry Building (Harry Bridges Plaza)
 
39016
San Francisco Caltrain Station 2 (Townsend St at 4th St)
 
36576
Other values (441)
2222936
ValueCountFrequency (%) 
Market St at 10th St450581.8%
 
Berry St at 4th St429621.7%
 
San Francisco Caltrain (Townsend St at 4th St)403021.6%
 
San Francisco Ferry Building (Harry Bridges Plaza)390161.6%
 
San Francisco Caltrain Station 2 (Townsend St at 4th St)365761.5%
 
Montgomery St BART Station (Market St at 2nd St)360811.4%
 
Powell St BART Station (Market St at 4th St)342531.4%
 
Steuart St at Market St324481.3%
 
Howard St at Beale St313411.3%
 
Powell St BART Station (Market St at 5th St)305811.2%
 
The Embarcadero at Sansome St287851.1%
 
2nd St at Townsend St244241.0%
 
3rd St at Townsend St230930.9%
 
Embarcadero BART Station (Beale St at Market St)220940.9%
 
4th St at Mission Bay Blvd S214370.9%
 
Townsend St at 7th St211160.8%
 
Beale St at Harrison St208180.8%
 
Civic Center/UN Plaza BART Station (Market St at McAllister St)205510.8%
 
4th St at 16th St200150.8%
 
The Embarcadero at Steuart St192190.8%
 
Howard St at 8th St183350.7%
 
Bancroft Way at College Ave173020.7%
 
Post St at Kearny St171580.7%
 
Rhode Island St at 17th St171000.7%
 
8th St at Brannan St161270.6%
 
Other values (421)175065869.8%
 
(Missing)801333.2%
 

Length

Max length63
Median length22
Mean length25.51926439
Min length3

Overview of Unicode Properties

Unique unicode characters67
Unique unicode categories (?)8
Unique unicode scripts (?)2
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
1077096816.8%
 
t877834213.7%
 
a60734549.5%
 
S44291186.9%
 
e33711355.3%
 
r31340144.9%
 
n30366224.7%
 
o25404444.0%
 
i18553302.9%
 
l17497112.7%
 
s14937512.3%
 
h13915932.2%
 
d11541151.8%
 
c8842801.4%
 
B8599341.3%
 
A7968631.2%
 
y7230391.1%
 
k6741591.1%
 
v6303031.0%
 
T6207421.0%
 
M6144011.0%
 
P5436460.8%
 
F4536040.7%
 
m4472750.7%
 
w4380800.7%
 
Other values (42)651143910.2%
 

Most occurring categories

ValueCountFrequency (%) 
Lowercase Letter3992971862.4%
 
Space Separator1077096816.8%
 
Uppercase Letter1064329016.6%
 
Decimal Number18556612.9%
 
Open Punctuation3663930.6%
 
Close Punctuation3663930.6%
 
Other Punctuation438820.1%
 
Dash Punctuation57< 0.1%
 

Most frequent Uppercase Letter characters

ValueCountFrequency (%) 
S442911841.6%
 
B8599348.1%
 
A7968637.5%
 
T6207425.8%
 
M6144015.8%
 
P5436465.1%
 
F4536044.3%
 
C4165863.9%
 
R3232083.0%
 
H3159833.0%
 
E1798901.7%
 
D1515171.4%
 
V1478221.4%
 
G1405551.3%
 
W1370971.3%
 
N932990.9%
 
J903250.8%
 
K869150.8%
 
L805830.8%
 
U597710.6%
 
O580200.5%
 
I313440.3%
 
Y120030.1%
 
Q64< 0.1%
 

Most frequent Lowercase Letter characters

ValueCountFrequency (%) 
t877834222.0%
 
a607345415.2%
 
e33711358.4%
 
r31340147.8%
 
n30366227.6%
 
o25404446.4%
 
i18553304.6%
 
l17497114.4%
 
s14937513.7%
 
h13915933.5%
 
d11541152.9%
 
c8842802.2%
 
y7230391.8%
 
k6741591.7%
 
v6303031.6%
 
m4472751.1%
 
w4380801.1%
 
u4352191.1%
 
g3976051.0%
 
b2895800.7%
 
p1501610.4%
 
z1225280.3%
 
f1040250.3%
 
q379240.1%
 
j10514< 0.1%
 

Most frequent Space Separator characters

ValueCountFrequency (%) 
10770968100.0%
 

Most frequent Open Punctuation characters

ValueCountFrequency (%) 
(366393100.0%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
141682022.5%
 
235758619.3%
 
430356916.4%
 
51751139.4%
 
71364987.4%
 
31150286.2%
 
01062145.7%
 
9880654.7%
 
6788224.2%
 
8779464.2%
 

Most frequent Close Punctuation characters

ValueCountFrequency (%) 
)366393100.0%
 

Most frequent Other Punctuation characters

ValueCountFrequency (%) 
/2393054.5%
 
'1328330.3%
 
&666915.2%
 

Most frequent Dash Punctuation characters

ValueCountFrequency (%) 
-57100.0%
 

Most occurring scripts

ValueCountFrequency (%) 
Latin5057300879.0%
 
Common1340335421.0%
 

Most frequent Latin characters

ValueCountFrequency (%) 
t877834217.4%
 
a607345412.0%
 
S44291188.8%
 
e33711356.7%
 
r31340146.2%
 
n30366226.0%
 
o25404445.0%
 
i18553303.7%
 
l17497113.5%
 
s14937513.0%
 
h13915932.8%
 
d11541152.3%
 
c8842801.7%
 
B8599341.7%
 
A7968631.6%
 
y7230391.4%
 
k6741591.3%
 
v6303031.2%
 
T6207421.2%
 
M6144011.2%
 
P5436461.1%
 
F4536040.9%
 
m4472750.9%
 
w4380800.9%
 
u4352190.9%
 
Other values (25)34438346.8%
 

Most frequent Common characters

ValueCountFrequency (%) 
1077096880.4%
 
14168203.1%
 
(3663932.7%
 
)3663932.7%
 
23575862.7%
 
43035692.3%
 
51751131.3%
 
71364981.0%
 
31150280.9%
 
01062140.8%
 
9880650.7%
 
6788220.6%
 
8779460.6%
 
/239300.2%
 
'132830.1%
 
&6669< 0.1%
 
-57< 0.1%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII63976362100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
1077096816.8%
 
t877834213.7%
 
a60734549.5%
 
S44291186.9%
 
e33711355.3%
 
r31340144.9%
 
n30366224.7%
 
o25404444.0%
 
i18553302.9%
 
l17497112.7%
 
s14937512.3%
 
h13915932.2%
 
d11541151.8%
 
c8842801.4%
 
B8599341.3%
 
A7968631.2%
 
y7230391.1%
 
k6741591.1%
 
v6303031.0%
 
T6207421.0%
 
M6144011.0%
 
P5436460.8%
 
F4536040.7%
 
m4472750.7%
 
w4380800.7%
 
Other values (42)651143910.2%
 

start_station_latitude
Real number (ℝ≥0)

SKEWED

Distinct count74719
Unique (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.7650637139919
Minimum0.0
Maximum45.51
Zeros12
Zeros (%)< 0.1%
Memory size19.1 MiB

Quantile statistics

Minimum0
5-th percentile37.3448821
Q137.7693053
median37.780526
Q337.79539294
95-th percentile37.866249
Maximum45.51
Range45.51
Interquartile range (IQR)0.0260876373

Descriptive statistics

Standard deviation0.13636983
Coefficient of variation (CV)0.003611004898
Kurtosis28171.78928
Mean37.76506371
Median Absolute Deviation (MAD)0.013604
Skewness-103.0494041
Sum94676372.72
Variance0.01859673054
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
37.776619450581.8%
 
37.77588429621.7%
 
37.776598403031.6%
 
37.795392390161.6%
 
37.7766392365761.5%
 
37.7896254360811.4%
 
37.78637527342531.4%
 
37.79413324481.3%
 
37.789756313411.3%
 
37.78389936305811.2%
 
37.80477287851.1%
 
37.780526244241.0%
 
37.77874161230930.9%
 
37.792251220940.9%
 
37.7704074214370.9%
 
37.771058211160.8%
 
37.7880593208180.8%
 
37.7810737205510.8%
 
37.76704458200150.8%
 
37.791464192210.8%
 
37.7765126183350.7%
 
37.8693603173020.7%
 
37.788975171580.7%
 
37.7644783171000.7%
 
37.77143136161270.6%
 
Other values (74694)183078873.0%
 
ValueCountFrequency (%) 
012< 0.1%
 
36.163261171< 0.1%
 
36.1633071< 0.1%
 
36.163310831< 0.1%
 
36.1634491< 0.1%
 
36.163581< 0.1%
 
37.268048671< 0.1%
 
37.279518331< 0.1%
 
37.27961551< 0.1%
 
37.279627671< 0.1%
 
ValueCountFrequency (%) 
45.514< 0.1%
 
39.89256712< 0.1%
 
37.895300171< 0.1%
 
37.892186671< 0.1%
 
37.891296671< 0.1%
 
37.88821451< 0.1%
 
37.888051831< 0.1%
 
37.885791671< 0.1%
 
37.885772831< 0.1%
 
37.885752831< 0.1%
 

start_station_longitude
Real number (ℝ)

SKEWED

Distinct count75943
Unique (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-122.3499194884997
Minimum-122.5142991667
Maximum0.0
Zeros12
Zeros (%)< 0.1%
Memory size19.1 MiB

Quantile statistics

Minimum-122.5142992
5-th percentile-122.4335369
Q1-122.4130036
median-122.3982847
Q3-122.2914153
95-th percentile-121.9086179
Maximum0
Range122.5142992
Interquartile range (IQR)0.1215883

Descriptive statistics

Standard deviation0.3089648379
Coefficient of variation (CV)-0.002525255751
Kurtosis119481.8018
Mean-122.3499195
Median Absolute Deviation (MAD)0.0165324263
Skewness309.5870215
Sum-306729168.2
Variance0.09545927105
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-122.417385450581.8%
 
-122.39317429621.7%
 
-122.395282403021.6%
 
-122.394203390161.6%
 
-122.3955263365761.5%
 
-122.400811360811.4%
 
-122.4049044342531.4%
 
-122.39443324481.3%
 
-122.394643313411.3%
 
-122.4084449305811.2%
 
-122.403234287851.1%
 
-122.390288244241.0%
 
-122.3927408230930.9%
 
-122.397086220940.9%
 
-122.3911984214370.9%
 
-122.402717211160.8%
 
-122.3918648208180.8%
 
-122.4117382205510.8%
 
-122.3908335200150.8%
 
-122.391034192190.8%
 
-122.4113061183350.7%
 
-122.2543374173020.7%
 
-122.403452171580.7%
 
-122.4025701171000.7%
 
-122.4057868161270.6%
 
Other values (75918)183079173.0%
 
ValueCountFrequency (%) 
-122.51429921< 0.1%
 
-122.5138471< 0.1%
 
-122.51383781< 0.1%
 
-122.51381621< 0.1%
 
-122.51379851< 0.1%
 
-122.51377671< 0.1%
 
-122.51314271< 0.1%
 
-122.51194821< 0.1%
 
-122.51174351< 0.1%
 
-122.51170971< 0.1%
 
ValueCountFrequency (%) 
012< 0.1%
 
-73.574< 0.1%
 
-75.173714162< 0.1%
 
-86.775177171< 0.1%
 
-86.775634171< 0.1%
 
-86.77576851< 0.1%
 
-86.775811671< 0.1%
 
-86.776017671< 0.1%
 
-121.81174851< 0.1%
 
-121.81342521< 0.1%
 

end_station_id
Real number (ℝ≥0)

MISSING

Distinct count436
Unique (%)< 0.1%
Missing82902
Missing (%)3.3%
Infinite0
Infinite (%)0.0%
Mean142.70442406833766
Minimum3.0
Maximum498.0
Zeros0
Zeros (%)0.0%
Memory size19.1 MiB

Quantile statistics

Minimum3
5-th percentile8
Q143
median101
Q3239
95-th percentile373
Maximum498
Range495
Interquartile range (IQR)196

Descriptive statistics

Standard deviation121.4296491
Coefficient of variation (CV)0.8509172009
Kurtosis-0.4842603229
Mean142.7044241
Median Absolute Deviation (MAD)78
Skewness0.8058184619
Sum345927083
Variance14745.15968
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
67521462.1%
 
30509432.0%
 
15481801.9%
 
21478861.9%
 
58442841.8%
 
81422311.7%
 
3374661.5%
 
16333191.3%
 
6332861.3%
 
5315401.3%
 
22294591.2%
 
50256771.0%
 
93250461.0%
 
90233420.9%
 
44232080.9%
 
17222230.9%
 
66217130.9%
 
27216210.9%
 
350199840.8%
 
104199250.8%
 
23197360.8%
 
61190020.8%
 
19181110.7%
 
114180540.7%
 
182170930.7%
 
Other values (411)167860667.0%
 
(Missing)829023.3%
 
ValueCountFrequency (%) 
3374661.5%
 
472630.3%
 
5315401.3%
 
6332861.3%
 
796460.4%
 
8107210.4%
 
9100790.4%
 
10111980.4%
 
11121620.5%
 
1232840.1%
 
ValueCountFrequency (%) 
49810< 0.1%
 
49524< 0.1%
 
49411< 0.1%
 
493360< 0.1%
 
49233< 0.1%
 
49110< 0.1%
 
49058< 0.1%
 
48967< 0.1%
 
48812< 0.1%
 
487329< 0.1%
 

end_station_name
Categorical

HIGH CARDINALITY
MISSING

Distinct count446
Unique (%)< 0.1%
Missing82350
Missing (%)3.3%
Memory size19.1 MiB
San Francisco Caltrain Station 2 (Townsend St at 4th St)
 
52146
San Francisco Caltrain (Townsend St at 4th St)
 
50943
San Francisco Ferry Building (Harry Bridges Plaza)
 
48180
Montgomery St BART Station (Market St at 2nd St)
 
47886
Market St at 10th St
 
44284
Other values (441)
2181194
ValueCountFrequency (%) 
San Francisco Caltrain Station 2 (Townsend St at 4th St)521462.1%
 
San Francisco Caltrain (Townsend St at 4th St)509432.0%
 
San Francisco Ferry Building (Harry Bridges Plaza)481801.9%
 
Montgomery St BART Station (Market St at 2nd St)478861.9%
 
Market St at 10th St442841.8%
 
Berry St at 4th St422311.7%
 
Powell St BART Station (Market St at 4th St)374661.5%
 
Steuart St at Market St333191.3%
 
The Embarcadero at Sansome St332861.3%
 
Powell St BART Station (Market St at 5th St)315401.3%
 
Howard St at Beale St294591.2%
 
2nd St at Townsend St256771.0%
 
4th St at Mission Bay Blvd S250461.0%
 
Townsend St at 7th St233420.9%
 
Civic Center/UN Plaza BART Station (Market St at McAllister St)232080.9%
 
Embarcadero BART Station (Beale St at Market St)222230.9%
 
3rd St at Townsend St217130.9%
 
Beale St at Harrison St216210.9%
 
8th St at Brannan St199840.8%
 
4th St at 16th St199250.8%
 
The Embarcadero at Steuart St197360.8%
 
Howard St at 8th St190020.8%
 
Post St at Kearny St181110.7%
 
Rhode Island St at 17th St180540.7%
 
19th Street BART Station170930.7%
 
Other values (421)167915867.0%
 
(Missing)823503.3%
 

Length

Max length63
Median length22
Mean length26.1590633
Min length3

Overview of Unicode Properties

Unique unicode characters67
Unique unicode categories (?)8
Unique unicode scripts (?)2
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
1101218016.8%
 
t892968613.6%
 
a62201319.5%
 
S45367116.9%
 
e33062645.0%
 
n32735855.0%
 
r32085794.9%
 
o26037444.0%
 
i19926413.0%
 
l17356522.6%
 
s15522762.4%
 
h14256482.2%
 
d11973181.8%
 
c9273131.4%
 
B8929461.4%
 
A7894251.2%
 
y7389281.1%
 
T6725171.0%
 
k6604641.0%
 
M6421641.0%
 
v6009120.9%
 
P5411990.8%
 
F4941560.8%
 
m4816480.7%
 
w4593190.7%
 
Other values (42)668492110.2%
 

Most occurring categories

ValueCountFrequency (%) 
Lowercase Letter4087310762.3%
 
Space Separator1101218016.8%
 
Uppercase Letter1088908616.6%
 
Decimal Number19238892.9%
 
Open Punctuation4187340.6%
 
Close Punctuation4187340.6%
 
Other Punctuation445410.1%
 
Dash Punctuation56< 0.1%
 

Most frequent Uppercase Letter characters

ValueCountFrequency (%) 
S453671141.7%
 
B8929468.2%
 
A7894257.2%
 
T6725176.2%
 
M6421645.9%
 
P5411995.0%
 
F4941564.5%
 
C4204953.9%
 
R3441723.2%
 
H3118242.9%
 
E1827931.7%
 
V1460151.3%
 
D1412131.3%
 
W1318011.2%
 
G1312201.2%
 
N999380.9%
 
K844470.8%
 
J825140.8%
 
L795930.7%
 
U657420.6%
 
O528510.5%
 
I334170.3%
 
Y118910.1%
 
Q42< 0.1%
 

Most frequent Lowercase Letter characters

ValueCountFrequency (%) 
t892968621.8%
 
a622013115.2%
 
e33062648.1%
 
n32735858.0%
 
r32085797.9%
 
o26037446.4%
 
i19926414.9%
 
l17356524.2%
 
s15522763.8%
 
h14256483.5%
 
d11973182.9%
 
c9273132.3%
 
y7389281.8%
 
k6604641.6%
 
v6009121.5%
 
m4816481.2%
 
w4593191.1%
 
u4382431.1%
 
g4008571.0%
 
b2964260.7%
 
p1414340.3%
 
z1323350.3%
 
f966270.2%
 
q349580.1%
 
j10721< 0.1%
 

Most frequent Space Separator characters

ValueCountFrequency (%) 
11012180100.0%
 

Most frequent Open Punctuation characters

ValueCountFrequency (%) 
(418734100.0%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
142795722.2%
 
237682519.6%
 
433031117.2%
 
51708198.9%
 
71432147.4%
 
31157856.0%
 
01042645.4%
 
9901114.7%
 
8825734.3%
 
6820304.3%
 

Most frequent Close Punctuation characters

ValueCountFrequency (%) 
)418734100.0%
 

Most frequent Other Punctuation characters

ValueCountFrequency (%) 
/2649259.5%
 
'1051023.6%
 
&753916.9%
 

Most frequent Dash Punctuation characters

ValueCountFrequency (%) 
-56100.0%
 

Most occurring scripts

ValueCountFrequency (%) 
Latin5176219378.9%
 
Common1381813421.1%
 

Most frequent Latin characters

ValueCountFrequency (%) 
t892968617.3%
 
a622013112.0%
 
S45367118.8%
 
e33062646.4%
 
n32735856.3%
 
r32085796.2%
 
o26037445.0%
 
i19926413.8%
 
l17356523.4%
 
s15522763.0%
 
h14256482.8%
 
d11973182.3%
 
c9273131.8%
 
B8929461.7%
 
A7894251.5%
 
y7389281.4%
 
T6725171.3%
 
k6604641.3%
 
M6421641.2%
 
v6009121.2%
 
P5411991.0%
 
F4941561.0%
 
m4816480.9%
 
w4593190.9%
 
u4382430.8%
 
Other values (25)34407246.6%
 

Most frequent Common characters

ValueCountFrequency (%) 
1101218079.7%
 
14279573.1%
 
(4187343.0%
 
)4187343.0%
 
23768252.7%
 
43303112.4%
 
51708191.2%
 
71432141.0%
 
31157850.8%
 
01042640.8%
 
9901110.7%
 
8825730.6%
 
6820300.6%
 
/264920.2%
 
'105100.1%
 
&75390.1%
 
-56< 0.1%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII65580327100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
1101218016.8%
 
t892968613.6%
 
a62201319.5%
 
S45367116.9%
 
e33062645.0%
 
n32735855.0%
 
r32085794.9%
 
o26037444.0%
 
i19926413.0%
 
l17356522.6%
 
s15522762.4%
 
h14256482.2%
 
d11973181.8%
 
c9273131.4%
 
B8929461.4%
 
A7894251.2%
 
y7389281.1%
 
T6725171.0%
 
k6604641.0%
 
M6421641.0%
 
v6009120.9%
 
P5411990.8%
 
F4941560.8%
 
m4816480.7%
 
w4593190.7%
 
Other values (42)668492110.2%
 

end_station_latitude
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED

Distinct count76905
Unique (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.76421902594531
Minimum0.0
Maximum45.51
Zeros80
Zeros (%)< 0.1%
Memory size19.1 MiB

Quantile statistics

Minimum0
5-th percentile37.3448821
Q137.7700298
median37.7807601
Q337.79587283
95-th percentile37.8660431
Maximum45.51
Range45.51
Interquartile range (IQR)0.0258430333

Descriptive statistics

Standard deviation0.2392885015
Coefficient of variation (CV)0.006336381572
Kurtosis19795.20156
Mean37.76421903
Median Absolute Deviation (MAD)0.0137155203
Skewness-125.689168
Sum94674255.11
Variance0.05725898695
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
37.7766392521462.1%
 
37.776598509432.0%
 
37.795392481801.9%
 
37.7896254478861.9%
 
37.776619442841.8%
 
37.77588422321.7%
 
37.78637527374661.5%
 
37.79413333191.3%
 
37.80477332861.3%
 
37.78389936315401.3%
 
37.789756294591.2%
 
37.780526256771.0%
 
37.7704074250461.0%
 
37.771058233420.9%
 
37.7810737232080.9%
 
37.792251222230.9%
 
37.77874161217130.9%
 
37.7880593216210.9%
 
37.77143136199840.8%
 
37.76704458199250.8%
 
37.791464197360.8%
 
37.7765126190020.8%
 
37.788975181120.7%
 
37.7644783180540.7%
 
37.870139164050.7%
 
Other values (76880)176219470.3%
 
ValueCountFrequency (%) 
080< 0.1%
 
36.163141< 0.1%
 
36.163385331< 0.1%
 
36.16342051< 0.1%
 
36.163459671< 0.1%
 
36.163581< 0.1%
 
36.739538171< 0.1%
 
37.226100331< 0.1%
 
37.2449871< 0.1%
 
37.24646251< 0.1%
 
ValueCountFrequency (%) 
45.514< 0.1%
 
39.89256712< 0.1%
 
37.912955331< 0.1%
 
37.912853671< 0.1%
 
37.902951331< 0.1%
 
37.899877831< 0.1%
 
37.89987151< 0.1%
 
37.899865171< 0.1%
 
37.895240171< 0.1%
 
37.892171< 0.1%
 

end_station_longitude
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct count77995
Unique (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-122.34590784656719
Minimum-122.5142868333
Maximum0.0
Zeros80
Zeros (%)< 0.1%
Memory size19.1 MiB

Quantile statistics

Minimum-122.5142868
5-th percentile-122.4310597
Q1-122.4117258
median-122.398113
Q3-122.2933996
95-th percentile-121.9086179
Maximum0
Range122.5142868
Interquartile range (IQR)0.1183262276

Descriptive statistics

Standard deviation0.708041743
Coefficient of variation (CV)-0.005787212302
Kurtosis28510.04618
Mean-122.3459078
Median Absolute Deviation (MAD)0.0136251877
Skewness165.6630369
Sum-306719111.1
Variance0.5013231098
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-122.3955263521462.1%
 
-122.395282509432.0%
 
-122.394203481801.9%
 
-122.400811478861.9%
 
-122.417385442841.8%
 
-122.39317422311.7%
 
-122.4049044374661.5%
 
-122.39443333191.3%
 
-122.403234332861.3%
 
-122.4084449315401.3%
 
-122.394643294591.2%
 
-122.390288256771.0%
 
-122.3911984250461.0%
 
-122.402717233420.9%
 
-122.4117382232080.9%
 
-122.397086222230.9%
 
-122.3927408217130.9%
 
-122.3918648216210.9%
 
-122.4057868199840.8%
 
-122.3908335199250.8%
 
-122.391034197360.8%
 
-122.4113061190020.8%
 
-122.403452181110.7%
 
-122.4025701180540.7%
 
-122.268422164050.7%
 
Other values (77970)176219670.3%
 
ValueCountFrequency (%) 
-122.51428681< 0.1%
 
-122.51382421< 0.1%
 
-122.51381931< 0.1%
 
-122.5138181< 0.1%
 
-122.51380321< 0.1%
 
-122.51380081< 0.1%
 
-122.51379051< 0.1%
 
-122.51315951< 0.1%
 
-122.51246621< 0.1%
 
-122.51194831< 0.1%
 
ValueCountFrequency (%) 
080< 0.1%
 
-73.574< 0.1%
 
-75.173714162< 0.1%
 
-86.775177171< 0.1%
 
-86.775728331< 0.1%
 
-86.77579351< 0.1%
 
-86.775805171< 0.1%
 
-86.77585451< 0.1%
 
-121.4694531< 0.1%
 
-121.73361531< 0.1%
 

bike_id
Real number (ℝ≥0)

Distinct count11070
Unique (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27898.32716177174
Minimum4
Maximum999941
Zeros0
Zeros (%)0.0%
Memory size19.1 MiB

Quantile statistics

Minimum4
5-th percentile399
Q11952
median4420
Q39682
95-th percentile13066
Maximum999941
Range999937
Interquartile range (IQR)7730

Descriptive statistics

Standard deviation114606.6512
Coefficient of variation (CV)4.108011585
Kurtosis32.60656269
Mean27898.32716
Median Absolute Deviation (MAD)2711
Skewness5.589032711
Sum6.994063192e+10
Variance1.31346845e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3135912< 0.1%
 
3146911< 0.1%
 
3569889< 0.1%
 
3249882< 0.1%
 
1502882< 0.1%
 
3009874< 0.1%
 
1406871< 0.1%
 
2174866< 0.1%
 
2692862< 0.1%
 
2293862< 0.1%
 
1258861< 0.1%
 
27855< 0.1%
 
1566850< 0.1%
 
2119848< 0.1%
 
2497848< 0.1%
 
1396844< 0.1%
 
1044840< 0.1%
 
1368840< 0.1%
 
3147838< 0.1%
 
1667837< 0.1%
 
3589835< 0.1%
 
3379832< 0.1%
 
1886830< 0.1%
 
3491830< 0.1%
 
1821828< 0.1%
 
Other values (11045)248555699.1%
 
ValueCountFrequency (%) 
42< 0.1%
 
11211< 0.1%
 
12570< 0.1%
 
13645< 0.1%
 
14321< 0.1%
 
15103< 0.1%
 
17322< 0.1%
 
18377< 0.1%
 
22384< 0.1%
 
24212< 0.1%
 
ValueCountFrequency (%) 
99994115< 0.1%
 
9999374< 0.1%
 
99942235< 0.1%
 
99843036< 0.1%
 
99808625< 0.1%
 
99739784< 0.1%
 
99696330< 0.1%
 
99656448< 0.1%
 
99509162< 0.1%
 
9932407< 0.1%
 

user_type
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.1 MiB
Subscriber
2021166
Customer
485817
ValueCountFrequency (%) 
Subscriber202116680.6%
 
Customer48581719.4%
 

Length

Max length10
Median length10
Mean length9.612428963
Min length8

Overview of Unicode Properties

Unique unicode characters12
Unique unicode categories (?)2
Unique unicode scripts (?)1
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
r452814918.8%
 
b404233216.8%
 
u250698310.4%
 
s250698310.4%
 
e250698310.4%
 
S20211668.4%
 
c20211668.4%
 
i20211668.4%
 
C4858172.0%
 
t4858172.0%
 
o4858172.0%
 
m4858172.0%
 

Most occurring categories

ValueCountFrequency (%) 
Lowercase Letter2159121389.6%
 
Uppercase Letter250698310.4%
 

Most frequent Uppercase Letter characters

ValueCountFrequency (%) 
S202116680.6%
 
C48581719.4%
 

Most frequent Lowercase Letter characters

ValueCountFrequency (%) 
r452814921.0%
 
b404233218.7%
 
u250698311.6%
 
s250698311.6%
 
e250698311.6%
 
c20211669.4%
 
i20211669.4%
 
t4858172.3%
 
o4858172.3%
 
m4858172.3%
 

Most occurring scripts

ValueCountFrequency (%) 
Latin24098196100.0%
 

Most frequent Latin characters

ValueCountFrequency (%) 
r452814918.8%
 
b404233216.8%
 
u250698310.4%
 
s250698310.4%
 
e250698310.4%
 
S20211668.4%
 
c20211668.4%
 
i20211668.4%
 
C4858172.0%
 
t4858172.0%
 
o4858172.0%
 
m4858172.0%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII24098196100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
r452814918.8%
 
b404233216.8%
 
u250698310.4%
 
s250698310.4%
 
e250698310.4%
 
S20211668.4%
 
c20211668.4%
 
i20211668.4%
 
C4858172.0%
 
t4858172.0%
 
o4858172.0%
 
m4858172.0%
 
Distinct count2
Unique (%)< 0.1%
Missing243259
Missing (%)9.7%
Memory size19.1 MiB
No
2086152
Yes
 
177572
(Missing)
 
243259
ValueCountFrequency (%) 
No208615283.2%
 
Yes1775727.1%
 
(Missing)2432599.7%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

duration_secstart_timeend_timestart_station_idstart_station_namestart_station_latitudestart_station_longitudeend_station_idend_station_nameend_station_latitudeend_station_longitudebike_iduser_typebike_share_for_all_trip
0608632019-09-30 11:48:02.71002019-10-01 04:42:25.8640465.0San Francisco Caltrain Station (King St at 4th St)37.776329-122.394438465.0San Francisco Caltrain Station (King St at 4th St)37.776329-122.39443812904CustomerNo
1360192019-09-30 16:16:32.35302019-10-01 02:16:51.9820294.0Pierce Ave at Market St37.327581-121.884559443.03rd St at Keyes St37.320866-121.876279163CustomerNo
256152019-09-30 23:12:25.99802019-10-01 00:46:01.9590370.0Jones St at Post St37.787327-122.4132784.0Cyril Magnin St at Ellis St37.785881-122.40891510737CustomerNo
314822019-09-30 23:57:34.66302019-10-01 00:22:16.8490109.017th St at Valencia St37.763316-122.421904460.0Terry Francois Blvd at Warriors Way37.769095-122.38633310346CustomerNo
412722019-09-30 23:53:28.65302019-10-01 00:14:41.074095.0Sanchez St at 15th St37.766219-122.431060127.0Valencia St at 21st St37.756708-122.4210251349SubscriberNo
586482019-09-30 21:43:51.01402019-10-01 00:07:59.893011.0Davis St at Jackson St37.797280-122.3984363.0Powell St BART Station (Market St at 4th St)37.786375-122.4049049806CustomerNo
66442019-09-30 23:54:43.10402019-10-01 00:05:27.656015.0San Francisco Ferry Building (Harry Bridges Plaza)37.795392-122.39420391.0Berry St at King St37.771762-122.3984389963SubscriberNo
74592019-09-30 23:54:42.86502019-10-01 00:02:22.3630321.05th St at Folsom37.780146-122.40307177.011th St at Natoma St37.773507-122.416040531SubscriberNo
86252019-09-30 23:49:31.70502019-09-30 23:59:56.916016.0Steuart St at Market St37.794130-122.39443080.0Townsend St at 5th St37.775235-122.39743710906SubscriberNo
911772019-09-30 23:39:34.08802019-09-30 23:59:11.2090433.0Gennessee St at Monterey Blvd37.731657-122.451122139.0Garfield Square (25th St at Harrison St)37.751017-122.41190111058CustomerNo

Last rows

duration_secstart_timeend_timestart_station_idstart_station_namestart_station_latitudestart_station_longitudeend_station_idend_station_nameend_station_latitudeend_station_longitudebike_iduser_typebike_share_for_all_trip
25069731222019-02-01 00:17:32.25802019-02-01 00:19:34.9380119.018th St at Noe St37.761047-122.432642120.0Mission Dolores Park37.761420-122.4264354326SubscriberNo
25069742492019-02-01 00:15:12.06702019-02-01 00:19:21.6990256.0Hearst Ave at Euclid Ave37.875112-122.260553247.0Fulton St at Bancroft Way37.867789-122.2658964642SubscriberNo
25069752562019-02-01 00:12:50.55402019-02-01 00:17:07.3620241.0Ashby BART Station37.852477-122.270213248.0Telegraph Ave at Ashby Ave37.855956-122.2597954845SubscriberYes
25069761112019-02-01 00:14:49.87402019-02-01 00:16:41.3010324.0Union Square (Powell St at Post St)37.788300-122.40853119.0Post St at Kearny St37.788975-122.4034524832SubscriberNo
25069777062019-02-01 00:04:40.61602019-02-01 00:16:27.0800138.0Jersey St at Church St37.750900-122.42741178.0Folsom St at 9th St37.773717-122.4116475017SubscriberNo
25069784802019-02-01 00:04:49.72402019-02-01 00:12:50.034027.0Beale St at Harrison St37.788059-122.391865324.0Union Square (Powell St at Post St)37.788300-122.4085314832SubscriberNo
25069793132019-02-01 00:05:34.74402019-02-01 00:10:48.502021.0Montgomery St BART Station (Market St at 2nd St)37.789625-122.40081166.03rd St at Townsend St37.778742-122.3927414960SubscriberNo
25069801412019-02-01 00:06:05.54902019-02-01 00:08:27.2200278.0The Alameda at Bush St37.331932-121.904888277.0Morrison Ave at Julian St37.333658-121.9085863824SubscriberYes
25069811392019-02-01 00:05:34.36002019-02-01 00:07:54.2870220.0San Pablo Ave at MLK Jr Way37.811351-122.273422216.0San Pablo Ave at 27th St37.817827-122.2756985095SubscriberNo
25069822712019-02-01 00:00:20.63602019-02-01 00:04:52.058024.0Spear St at Folsom St37.789677-122.39042837.02nd St at Folsom St37.785000-122.3959361057SubscriberNo